Soundex (string)

Basic and Crystal syntax.

Arguments

string is one of two or more strings that sound alike.

Returns

Text String

Action

Soundex (string) evaluates a text string and returns a four character value that symbolizes the way string sounds.

Typical uses

Use this function whenever you want to locate records based on two or more field values that are spelled differently yet sound alike.

This function can also be used to find customer names that have been misspelled.

Examples

The following examples are applicable to Crystal syntax:

If Soundex{customer.LAST NAME} = Soundex ("Snider") Then

    {customer.LAST NAME}

Else

    ""

Runs a Soundex on each value in the Last Name field and prints only those values that have a Soundex value equal to the Soundex value of the name Snider. This formula returns the names Sneider, Schneider, Snyder, and Snider if they are all in the database.

Comments


Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com